package jsu.lipengcheng.trafficnet.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import jsu.lipengcheng.trafficnet.pojo.ActivityUser;
import lombok.RequiredArgsConstructor;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ActivityUserMapper extends BaseMapper<ActivityUser> {

    @Select("select activity_id from activity_user where user_id=#{userid}")
    List<Integer> selectbyuserid(Integer userid);

    @Select("select * from activity_user where user_id=#{userid} and activity_id=#{id}")
    ActivityUser selectbyuseridid(Integer userid, Integer id);
}
